package com.hospital.dao;


import com.hospital.dto.EmployeeExportDto;
import com.hospital.entity.Employee;
import com.hospital.vo.BarVo;
import com.hospital.vo.JovPieVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface EmployeeDao {

    int add(Employee employee);

    int delete(Integer id);

    int deleteByIds(@Param("ids") String[] ids);

    int update(Employee employee);

    long count(@Param("name") String name,@Param("job_name") String job_name);

    Employee selectById(Integer id);

    List<BarVo> sexBarData();

    List<JovPieVo> jobPieData();

    List<Employee> selectPage(@Param("name") String name,@Param("job_name") String job_name, @Param("start") int start, @Param("size") int size);

    List<EmployeeExportDto> all();

}
